CREATE RULE StudentID_rule AS
	@StudentID LIKE "[A-Z][A-Z][0-9][0-9][0-9][0-9][0-9][0-9]";
GO

CREATE RULE Word_rule AS
	@Word NOT LIKE "%[0-9]%";
GO

sp_bindrule StudentID_rule, "Students.StudentID"
GO
sp_bindrule Word_rule, "Glossary.ForeignWord"
GO
sp_bindrule Word_rule, "Glossary.SwedishWord"
GO
sp_bindrule Word_rule, "Answers.Answer"
GO
sp_bindrule Word_rule, "Language.LanguageName"
GO